|
4979 Search Results Found |
1 |
Forum: Backup & Recovery «»
Posted on: Wed, 19 July 2023 01:32 «»
By: Andrey_R
PITR with RMAN not working
…- 14:00 29th of May 2023.
I got:
- 3 RMAN database backup files from that date taken at 11:00 in the morning
- All Archive logs created on the 29th of May 2023
The backups:
RMAN> list backup;
List of Backup Sets…
|
2 |
Forum: Data Guard «»
Posted on: Sat, 11 February 2023 11:31 «»
By: Andrey_R
Re: RMAN-06820 on rman backup from standby with OS authentication
…- my_dg_config
Protection Mode: MaxPerformance
Members:
orcl - Primary database
orcl_stby - Physical standby database
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS (status updated 53 seconds ago)
DGMGRL>…
|
3 |
Forum: Backup & Recovery «»
Posted on: Sun, 27 February 2022 13:40 «»
By: patdev
RMAN resotre/clone to new server
…all,
I am trying to restore the RMAN backup to new server.
I have done following steps:
1- created pfile from spfile (from target) copied ($/dbs) folder with change file location for adump, and ctl files
2- took source backup with current …
|
4 |
Forum: Server Administration «»
Posted on: Thu, 13 April 2023 06:25 «»
By: Andrey_R
No SCN in controlfile after BACKUP TO TRACE
… is the command I used to do the backup with RMAN
RMAN> alter database backup controlfile to trace as 'F:\ORACLE_BACKUP\\controlfile.txt';
using target database control file instead of recovery catalog
Statement processed
And here are the …
|
5 |
Forum: Backup & Recovery «»
Posted on: Thu, 06 July 2023 07:01 «»
By: Andrey_R
RMAN restore - only DB backup ( no SF\CF\archivelog backup )
…
SQ
I took a backup of the database:
RMAN> backup database format 'G:\BACKUP\BACKUP_MYDB\MYDB_BKP.RMAN';
Starting backup at 06-JUL-23
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=266 device type=DISK
channel ORA_DISK_1: starting …
|
6 |
Forum: Backup & Recovery «»
Posted on: Tue, 20 September 2022 20:00 «»
By: rcct
RMAN backups not registering in repository
…that backup because I wanted to take local RMAN backups, for cloning purposes. However, RMAN is behaving strangely:
1) The backup... command completes "successfully"
2) "list backup" only shows the controlfile backup, no datafile …
|
7 |
Forum: Backup & Recovery «»
Posted on: Mon, 14 March 2022 12:49 «»
By: varunvir
restore 11g to 19c using rman
Hi Experts,
Can we restore RMAN Backup taken from 11g directly on 19c?
Thanks,
Varun
|
8 |
Forum: Backup & Recovery «»
Posted on: Thu, 06 July 2023 09:41 «»
By: Andrey_R
Re: RMAN restore - only DB backup ( no SF\CF\archivelog backup )
…nbsp;mydb2
SQL>
So now, I tried to open rman with MYDB2 as auxiliary, however no luck, seems like I misused the Auxiliary option ..
C:\Users\Administrator>rman target sys/123@mydb auxiliary sys/123@mydb2
Recovery Manager: Release 19.0.0.0.0…
|
9 |
Forum: Data Guard «»
Posted on: Sat, 04 February 2023 15:43 «»
By: Andrey_R
RMAN-06820 on rman backup from standby with OS authentication
…such as:
https://doyensys.com/blogs/rman-06820-warning-failed-to-archive/
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=573376425708183&parent=EXTERNAL_SEARCH&sourceId=PROBLEM&i d=2723796.1&_afrWindowMode=0&_adf.…
|
10 |
Forum: Backup & Recovery «»
Posted on: Thu, 08 September 2022 17:25 «»
By: carlino70
Restore/Recover RAC 2 instances with RMAN
…you approach me to the procedure to perform a complete or incomplete restore (in case of loss of a datafile, for example), on the same server, from Oracle RAC with 2 instances.
I have doubts about how to handle each instance and the way they should …
|
11 |
Forum: Backup & Recovery «»
Posted on: Tue, 22 March 2022 15:08 «»
By: Glenstr
restoring RMAN backup to point in time on another server, different SID & directory structure
…was at 4 days ago, on prod server I do an RMAN backup with 7 day recovery window on disk, so all necessary backups reside on prod, which is fast recovery area on a Z: drive on prod server.
Test server does not have a Z drive, but I can map a Z drive …
|
12 |
Forum: Backup & Recovery «»
Posted on: Wed, 19 July 2023 03:03 «»
By: John Watson
Re: PITR with RMAN not working
…are you using SQL*Plus to do the recovery? RMAN will do it better.
THe approach I would take is:
Start the instance off a dummy parameter file (you are OK there, though you could ask RMAN to do that for you).
Tell RMAN to restore the spfile from …
|
13 |
Forum: Backup & Recovery «»
Posted on: Mon, 24 April 2023 02:08 «»
By: Pratiksha_Ratnaparkhi
Re: Oracle RMAN Backup API
…
I am using AWS EC2 instance. So to execute RMAN commands for AWS, I have to launch SQLPLUS CLI. And from there I will not be able to execute the rman command you provided as that utility is not present.
EX., I use rdsadmin_rman_util library on sqlplus …
|
14 |
Forum: Data Guard «»
Posted on: Sat, 11 February 2023 11:55 «»
By: Andrey_R
Re: RMAN-06820 on rman backup from standby with OS authentication
… process works from primary to standby - the RMAN backup on STANDBY is good enough in spite of the "hole" in the REDO that is current on Primary during the backup
I did not check what happens if redo transportation stops and recovery is …
|
15 |
Forum: Backup & Recovery «»
Posted on: Tue, 24 May 2022 13:58 «»
By: bwdavis59
10gR2 -> 19c
… the db_recovery_file_dest to it.
I can run RMAN and SQLPLUS locally with no issues and connect to the database I created.
Following what works from experience, I run rman and then to restore the backup:
set DBID = 1387211105;
RUN
{
startup …
|
16 |
Forum: Backup & Recovery «»
Posted on: Wed, 12 July 2023 10:29 «»
By: Andrey_R
Re: RMAN restore - only DB backup ( no SF\CF\archivelog backup )
…-00279"
Or I tried to restore with rman "Restore Database" and just "Recover database" and got
RMAN-08187: warning: media recovery until SCN 2462425437 complete
Finished recover at
But when trying to open with resetlogs…
|
17 |
Forum: Backup & Recovery «»
Posted on: Fri, 27 January 2023 21:14 «»
By: Barbara Boehmer
Re: ora-12203 TNS unable to connect
…missing target.
C:\Windows\System32>rman target system/system@orcl
Recovery Manager: Release 12.1.0.2.0 - Production on Fri Jan 27 19:09:00 2023
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to …
|
18 |
Forum: Backup & Recovery «»
Posted on: Wed, 16 March 2022 16:27 «»
By: varunvir
Re: Restore tablespace
… since from 11G TO 19c as you explained that RMAN rebuilds it from scratch.
I just wanted to confirm again.
We have a database 35 tbs of backups taken from 11g database that vendor is not gonna provide support 11g for since all the servers have been…
|
19 |
Forum: Data Guard «»
Posted on: Thu, 28 September 2023 01:25 «»
By: LIPEKA
RMAN-00554 RMAN-04006
…DITOR=vi
[rock_it_pc1@localhost dbs]$ rman target sys/password auxiliary sys/password@to_SALESPRDSBY
Recovery Manager: Release 19.0.0.0.0 - Production on Thu Sep 28 01:24:54 2023
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its…
|
20 |
Forum: Backup & Recovery «»
Posted on: Thu, 06 July 2023 07:57 «»
By: Andrey_R
Re: RMAN restore - only DB backup ( no SF\CF\archivelog backup )
…again - got the exact same result
RMAN> RECOVER TABLE "MYUSER"."T1"
2> UNTIL TIME "TO_DATE('06.07.2023 11:47:00', 'DD-MM-YYYY HH24:MI:SS')"
3> AUXILIARY DESTINATION 'G:\MYAUX'
4> REMAP TABLE 'MYUSER'.'T1…
|
21 |
Forum: Backup & Recovery «»
Posted on: Mon, 24 April 2023 02:34 «»
By: Michel Cadot
Re: Oracle RMAN Backup API
…:
SQL> host echo list incarnation;quit | rman target / nocatalog
Recovery Manager: Release 11.2.0.4.0 - Production on Lun. Avr. 24 09:32:39 2023
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to …
|
22 |
Forum: Backup & Recovery «»
Posted on: Fri, 21 April 2023 03:35 «»
By: Michel Cadot
Re: Oracle RMAN Backup API
… you can do it easily using something like:
rman target / nocatalog log=$LOGFILE append cmdfile=$CMDFILE
where $CMDFILE is a file containing your RMAN commands.
There is an API (DBMS_BACKUP_RESTORE) but it is not documented.
A description can be …
|
23 |
Forum: Backup & Recovery «»
Posted on: Fri, 21 April 2023 01:57 «»
By: Pratiksha_Ratnaparkhi
Re: Oracle RMAN Backup API
…I get it right.
If I want to integrate rman backup and recovery to my existing application, then I won't be able to do that using APIs, I need to manually launch RMAN console and execute backup and restore commands.
If this is right then,
Do you …
|
24 |
Forum: Backup & Recovery «»
Posted on: Wed, 21 September 2022 01:11 «»
By: Mahesh Rajendran
Re: RMAN backups not registering in repository
Is the rman client version compatible with rman repository schema? Is there a difference in the versions?
If a proper "resync catalog" did not work for you, try manually cataloging again
catalog start with
|
25 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 24 March 2022 07:34 «»
By: EdStevens
Re: DB last date
…in the backup file name NOT be correct? If you are using rman (as you should) why do you care? Rman will manage the file names, and know what is what. With online backps in archivelog mode, you can always restore/recover to a specified point in time…
|
26 |
Forum: Backup & Recovery «»
Posted on: Wed, 23 March 2022 12:08 «»
By: Glenstr
Re: restoring RMAN backup to point in time on another server, different SID & directory structure
… I answered - meant spfile.
I have not used RMAN to duplicate a DB often, the few DB's I do duplicate regularly I have a scripted procedure using the "old way" that works well & I just haven't got around to changing it to using RMAN…
|
27 |
Forum: Backup & Recovery «»
Posted on: Tue, 15 March 2022 10:24 «»
By: EdStevens
Re: restore 11g to 19c using rman
…blocks.
When you restore from an rman backup, you are not "restoring to" another database. You are rebuilding the original database that was backed up. Every time. So if you back up an 11g database and restore it under a 19c home, you …
|
28 |
Forum: Backup & Recovery «»
Posted on: Mon, 14 March 2022 18:24 «»
By: EdStevens
Re: restore 11g to 19c using rman
…note that restoreing a database from an rman backup is a process of rebuilding the physical data files, block by block. That means that if the backup was from an 11g database, the rman restore will rebuild that same 11g database. If you were to rebuild…
|
29 |
Forum: Marketplace «»
Posted on: Sun, 20 March 2016 11:35 «»
By: Michel Cadot
McOptions: a program which allows to know which options are used in a database
…sp; Recovery Manager (RMAN)  …
|
30 |
Forum: Server Administration «»
Posted on: Fri, 08 September 2023 00:43 «»
By: Michel Cadot
Re: Other way to get the Schema Size other than dba_segments view
… .001525879
MC_RMAN .000915527
MDSYS &…
|
31 |
Forum: Multitenant «»
Posted on: Wed, 26 July 2023 07:45 «»
By: SaschaG
RAM of Services goes up after swap to Multitenant
…is and move it to a different server (via RMAN Backup and Recovery).
What they've done is that premigration the DB was a single-container PDB and postmigration it now is a Multitenant PDB.
Everything seemed to be fine with the new databases since we…
|
32 |
Forum: Backup & Recovery «»
Posted on: Thu, 06 July 2023 11:25 «»
By: John Watson
Re: RMAN restore - only DB backup ( no SF\CF\archivelog backup )
…have created and started then (perhaps) it will work. RMAN will start the instance and connect to it, you shouldn't be doing that. I would think that instance_name is the only parameter you need so that it can find the service, but that's guessing…
|
33 |
Forum: Backup & Recovery «»
Posted on: Fri, 27 January 2023 19:52 «»
By: hissam78
Re: ora-12203 TNS unable to connect
I have tried to run the rman utility but showing the error , attached in .png format for your kind information. please guide
|
34 |
Forum: Backup & Recovery «»
Posted on: Fri, 27 January 2023 18:04 «»
By: hissam78
Re: ora-12203 TNS unable to connect
Thanks a lot Michel Cadot
I will follow your instruction, please let me know how to restore after taking rman backup in the database?
|
35 |
Forum: Backup & Recovery «»
Posted on: Fri, 27 January 2023 12:16 «»
By: Michel Cadot
Re: ora-12203 TNS unable to connect
E:\>rman target=/
Recovery Manager: Release 11.2.0.4.0 - Production on Ven. Janv. 27 19:15:52 2023
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: MIKB2 (DBID=288523517)
|
36 |
Forum: Security «»
Posted on: Wed, 06 July 2022 01:00 «»
By: John Watson
Re: Remove and Disable the HSM
This is a different question. I think you want to decrypt the columns, then do an RMAN duplicate. I can see no reason why that would not work. What happens when you try it?
|
37 |
Forum: Security «»
Posted on: Tue, 05 July 2022 12:57 «»
By: keenweng2001
Re: Remove and Disable the HSM
…on the hardware module . So that I can RMAN dump the database to other server (without HSM or TDE) for future references and move the HSM server to decommission .
I have cross check with script --- SELECT tablespace_name, encrypted, status FROM …
|
38 |
Forum: Performance Tuning «»
Posted on: Fri, 13 May 2022 05:17 «»
By: John Watson
excessive parsing ?
…have a performance issue that I think may be excessive parsing. It is a procedure that runs for close to three hours, and we need it to be under 10 minutes. In a statspack report for the run I see this,Time Model System Stats DB/Inst: redacted Snaps: …
|
39 |
Forum: Backup & Recovery «»
Posted on: Tue, 05 April 2022 15:44 «»
By: varunvir
importing last 3 months of data
Hi Experts,
Is it possible using expdp to copy last 3 months of data from db into a new database?
or
Is it possible to import last 3 months to new database into new database using RMAN?
Thanks,
Varun
|
40 |
Forum: Backup & Recovery «»
Posted on: Tue, 22 March 2022 15:48 «»
By: Glenstr
Re: restoring RMAN backup to point in time on another server, different SID & directory structure
… pm','mm/dd/yyyy hh24:mi:ss')";
Yes I do need to update/modernize my refresh procedures, the ones I use are old, but simple and relatively fast. When my 19c upgrades are done I will implement using RMAN to refresh test & dev databases…
|